<?php
/**
 * ShopEx licence
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['product']=array (
  'columns' =>
  array (
    'id' =>
    array (
      'type' => 'int unsigned',
      'required' => true,
      'pkey' => true,
      'extra' => 'auto_increment',
      'label' => app::get('tbdata')->_('产品自增id'),
      'width' => 110,
      'editable' => false,
	  'order'=>1,
      'in_list' => false,
    ),
    'product_id' =>
    array (
      'type' => 'int unsigned',
      'label' => app::get('tbdata')->_('淘宝产品id'),
      'width' => 110,
      'required' => true,
      'editable' => false,
      'in_list' => true,
	  'filtertype'=>'number',
      'filterdefault' => true,
    ),
    'outer_id' =>
    array (
      'type' => 'varchar(100)',
      'default' => '',
      'label' => app::get('tbdata')->_('属性名称'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'created' =>
    array (
      'type' => 'time',
      'label' => app::get('tbdata')->_('创建时间'),
      'width' => 110,
      'required' => true,
	  'default'=>0,
      'editable' => false,
      'in_list' => true,
    ),
    'modified' =>
    array (
      'type' => 'time',
      'label' => app::get('tbdata')->_('修改时间'),
      'width' => 110,
      'required' => true,
	  'default'=>0,
      'editable' => false,
      'in_list' => true,
    ),
    'tsc' =>
    array (
      'type' => 'varchar(100)',
      'default' => '',
      'label' => app::get('tbdata')->_('淘宝标准产品编码'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'cid' =>
    array (
      'type' => 'int unsigned',
      'label' => app::get('tbdata')->_('淘宝类目id'),
      'width' => 110,
      'required' => true,
      'editable' => false,
      'in_list' => true,
	  'filtertype'=>'yes',
      'default_in_list' => true,
      'filterdefault' => true,
    ),
    'cat_name' =>
    array (
      'type' => 'varchar(100)',
      'default' => '',
      'label' => app::get('tbdata')->_('商品类目名称'),
      'width' => 50,
      'editable' => false,
      'in_list' => true,
	  'order'=>1,
      'default_in_list' => true,
	  'filtertype'=>'number',
      'filterdefault' => true,
    ),
    'props' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的关键属性列表'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'props_str' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的关键属性字符串列表'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'binds_str' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的非关键属性字符串列表'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'sale_props_str' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的销售属性字符串列表'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'collect_num' =>
    array (
      'type' => 'int unsigned',
      'label' => app::get('tbdata')->_('产品的collect次数'),
      'width' => 110,
      'required' => false,
      'editable' => false,
      'in_list' => true,
    ),
    'name' =>
    array (
      'type' => 'varchar(255)',
      'default' => '',
      'label' => app::get('tbdata')->_('产品名称'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'binds' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的非关键属性列表'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'sale_props' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的销售属性列表'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'price' =>
    array (
      'type' => 'decimal(9,2)',
      'default' => '0',
      'label' => app::get('tbdata')->_('价格'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'desc' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的描述'),
      'width' => 110,
      'editable' => false,
      'in_list' => false,
    ),
    'pic_url' =>
    array (
      'type' => 'varchar(800)',
      'default' => '',
      'label' => app::get('tbdata')->_('pic_url'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'pic_path' =>
    array (
      'type' => 'varchar(800)',
      'default' => '',
      'label' => app::get('tbdata')->_('pic_path'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'product_imgs' =>
    array (
      'type' => 'serialize',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的子图片'),
      'width' => 110,
      'editable' => false,
      'in_list' => false,
    ),
    'product_prop_imgs' =>
    array (
      'type' => 'serialize',
      'default' => '',
      'label' => app::get('tbdata')->_('产品的属性图片'),
      'width' => 110,
      'editable' => false,
      'in_list' => false,
    ),
    'level' =>
    array (
      'type' => 'number',
      'label' => app::get('tbdata')->_('产品的级别level'),
      'width' => 110,
      'required' => true,
	  'default'=>0,
      'editable' => false,
      'in_list' => true,
    ),
    'vertical_market' =>
    array (
      'type' => 'number',
      'label' => app::get('tbdata')->_('垂直市场,如：3（3C），4（鞋城）'),
      'width' => 110,
      'required' => false,
      'editable' => false,
      'in_list' => true,
    ),
    'customer_props' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('用户自定义属性'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'property_alias' =>
    array (
      'type' => 'longtext',
      'default' => '',
      'label' => app::get('tbdata')->_('用户自定义属性'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
    ),
    'status' =>
    array (
      'type' =>
      array (
        '0' => app::get('tdata')->_('商家确认'),
        '1' => app::get('tdata')->_('屏蔽'),
        '3' => app::get('tdata')->_('小二确认'),
        '2' => app::get('tdata')->_('未确认'),
        '-1' => app::get('tdata')->_('已删除'),
      ),
      'required' => true,
      'label' => app::get('tbdata')->_('状态'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
    ),
    'goods_download_time' =>
    array (
      'type' => 'time',
      'label' => app::get('tbdata')->_('产品最后下载时间'),
      'width' => 110,
      'required' => true,
	  'default'=>0,
      'editable' => false,
      'in_list' => true,
    ),
    'last_modify' =>
    array (
      'type' => 'last_modify',
      'label' => app::get('tbdata')->_('更新时间'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
	  'default'=>0,
      'filtertype' => 'yes',
      'filterdefault' => true,
      'default_in_list' => true,
    ),
  ),
  'comment' => app::get('tbdata')->_('类别属性值表'),
  'index' =>
  array (
    'ind_cid' =>
    array (
      'columns' =>
      array (
        0 => 'cid',
      ),
    ),
    'ind_product_id' =>
    array (
      'columns' =>
      array (
        0 => 'product_id',
      ),
      'prefix' => 'UNIQUE',
    ),
  ),
  'version' => '$Rev: 41329 $',
);
